For examples I don't know how many rows in each table are and I try to do like this: SELECT * FROM members UNION SELECT * FROM inventory What can I put to the second SELECT instead of * to remov...

Why am i getting a #1222 - The used SELECT statements have a different number of columns ? i am trying to load wall posts from this users friends and his self. SELECT u.id AS pid, b2.id AS id, b2....

How would I select different columns from two different tables, such as: SELECT username, email FROM `table1` UNION SELECT * FROM `table2` WHERE username = 'user1'; I'm getting an error "#1222...

Why am I getting ERROR 1222 (21000): The used SELECT statements have a different number of columns from the following? SELECT * FROM friends LEFT JOIN users AS u1 ON users.uid = friends.fid1 LEFT J...