LEFT JOIN

[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.

 

[David Browne]

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).

LEFT JOIN and LEFT OUTER JOIN are the same thing.

David

 

[Jeff Dillon]

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

 

[tma]

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?

 

[Michelle]

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