code_junkie

SQL statement from two tables

Nov 12th, 2011
67
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.31 KB | None | 0 0
  1. CREATE TABLE tbl_1 (
  2. pk_1 int,
  3. field_1 varchar(25),
  4. field_2 varchar(25)
  5. );
  6.  
  7. CREATE TABLE tbl_2 (
  8. pk_2 int,
  9. fk_1 int,
  10. field_3 varchar(25),
  11. field_4 varchar(25)
  12. );
  13.  
  14. SELECT t1.field_1, t2.field_3
  15. FROM tbl_1 t1
  16. INNER JOIN tbl_2 t2 ON t1.pk_1 = t2.fk_1
  17. WHERE t2.field_3 = "Some String"
Add Comment
Please, Sign In to add comment