Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Is there some way to select the first table without writing all the fields names in the query?
- SELECT DISTINCT t1.*
- from T1
- join t2 on condition
- SELECT DISTINCT T1.*
- FROM T1 JOIN T2 ON T1.id = T2.id;
- SELECT *
- FROM T1
- WHERE id IN (SELECT id FROM T2);
Advertisement
Add Comment
Please, Sign In to add comment