Query Help

[slevytam]

Hello everyone,

I just was hoping someone could help me out with this query.

I have two tables.

Table one: Users
Table two: Usersmedia

I would like to select all records from users; however, I would like to link usersmedia rows that match field(ID) only if they exist.

I know this isn't that clear. I will try an example.

I want this to work,
Select * from users, usersmedia where users.ID=usersmedia.ID;

But if there isn't a line in usersmedia that has the corresponding ID then I would like only the fields from users for the ID
Select * from users;

The problem is if I use the first line and there is no corresponding ID in usersmedia then I get no row for that ID. I would still like the fields from users even if their is no match in usersmedia

I hope this isn't to incoherant.

Thanks,

--SL

[nnichols]

Select * from users
LEFT JOIN usersmedia
ON users.ID=usersmedia.ID

Hope this helps 😉

[slevytam]

Beautiful,

I only needed one slight modification for my purposes!

Can you do this with more than one table?

ie

select * from users Left Join usersmedia On users.ID=usersmedia.ID Left Join usersinfo on users.ID=usersinfo.ID;

Thanks again,

--SL

[bcrockett]

Sure you can - that will work fine.

[slevytam]

Thanks!