[SOLVED] Which join should I be using
Moderator: General Moderators
-
impulse()
- Forum Regular
- Posts: 748
- Joined: Wed Aug 09, 2006 8:36 am
- Location: Staffordshire, UK
- Contact:
[SOLVED] Which join should I be using
I have 2 tables and I want all the data from table 1 to be displayed and I want 1 field from table 2 to be joined onto the side, whether the field is blank or contains data. But at the moment it's either outputting 38,000+ rows when there should only be 3000 rows.
Last edited by impulse() on Sun Aug 26, 2007 8:30 am, edited 1 time in total.
We've all done that, but please do us a favor: please go back and edit the Subject of your post to indicate [RESOLVED] so that hundreds more of us don't spend the time reading the thread, only to realize that there is no longer a problem. Thank you.impulse() wrote:It was my fault, I was being totally stupid and joining on the wrong fields. It was a left join though.