in
All Tags » inner join (RSS)

Browse by Tags

  • Inner Join and Where clause issue

    Have a bit of a problem with Inner Joins and where clauses. I start with the below query: Dim q As SubSonic.SqlQuery = New SubSonic.Select(cols) _ .From(Of Job) _ .InnerJoin(Equipment.EquipmentIDColumn, Job.EquipmentIDColumn) _ .InnerJoin(Product.ProductIDColumn, Equipment.ProductIDColumn) _ .InnerJoin...
    Posted to Version 2.1 - Pakala (Forum) by k_man on 03-23-2008

  • Re: Are multiple references to the same table handled?

    After a couple of days with no answer I figured that I'd take a crack at implimenting this feature -- I believe that I have success!! First of all I have only implimented this as a feature for the FROM table when you use the CreateJoin(string fromTable, string fromColumn, string toTable, string toColumn...
    Posted to Version 2.1 - Pakala (Forum) by dhigginx on 03-22-2008

  • Re: Are multiple references to the same table handled?

    When the Select includes .InnerJoin(ParaSonic.Lookup.LookupIDColumn, ParaSonic.CustomerContact.DispoCodeColumn) .InnerJoin(ParaSonic.Lookup.LookupIDColumn, ParaSonic.CustomerContact.MarriedIDColumn) I Get a SQLQueryException: The objects "dbo.Lookup" and "dbo.Lookup" in the FROM clause...
    Posted to Version 2.1 - Pakala (Forum) by dhigginx on 03-19-2008

  • Are multiple references to the same table handled?

    I have several of the tables that have multiple references to the same table. In a SQL Query I would write something like: SELECT cc.*, L1.LookupName as InsCompany, L2.LookupName as RecentPurch FROM CustomerContact AS cc INNER JOIN Lookup AS L1 ON cc.InsCompanyID = L1.LookupID INNER JOIN Lookup AS L2...
    Posted to Version 2.1 - Pakala (Forum) by dhigginx on 03-17-2008

  • Re: Joins The SubSonic way

    Has this code for Join Queries been implemented in any way in the current build of SubSonic? Thanks.
    Posted to Code Share (Forum) by TheMez on 03-13-2008

  • Inner Join Issue

    First, let me say SubSonic rocks. I have only just started using it but the time it has already saved me has been huge. I think there is an issue with Inner Joins (built from Pakala Trunk on 3/5 - 3/6). Or I am so sleep deprived that I am missing something obvious. My code: Dim dt As New DataTable Dim...
    Posted to Version 2.1 - Pakala (Forum) by k_man on 03-06-2008
Page 1 of 1 (6 items)