LEFT JOIN

  • Thread starter Thread starter tma
  • Start date Start date
T

tma

How do I accomplish the equivalent of a LEFT JOIN in the VS Designer?

I want all items from Table1 and any from Table2 that match. With or without
matches from Table2, I need all the items from Table1. I thought this was a
LEFT JOIN but VS is making it a LEFT OUTER JOIN and returning 10million
records (a bit exaggerated).

Thanks.
 
tma said:
How do I accomplish the equivalent of a LEFT JOIN in the VS Designer?

I want all items from Table1 and any from Table2 that match. With or
without
matches from Table2, I need all the items from Table1. I thought this was
a
LEFT JOIN but VS is making it a LEFT OUTER JOIN and returning 10million
records (a bit exaggerated).
Click to expand...

LEFT JOIN and LEFT OUTER JOIN are the same thing.

David
 
Use SQL View in the Designer, and write it yourself, using the syntax from a
previous post.

What object are you trying to set the CommandText for?

Jeff
 
What I'm still confused about is why my LEFT JOIN is not limited to the
number of records in my Table1. Again, I want to show all items in Table1,
and any in Table2 should be joined by ItemID. Is a LEFT JOIN what I need?
 
You should use Table1 Left Join Table2 on Table1.ItemID =
Table2.ItemID

If Table2 has more than one record that has the item id
in it, you will return more rows than you originally had
in table 1.

Hope this helps
 
Back
Top