Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE TABLE tbl_1 (
- pk_1 int,
- field_1 varchar(25),
- field_2 varchar(25)
- );
- CREATE TABLE tbl_2 (
- pk_2 int,
- fk_1 int,
- field_3 varchar(25),
- field_4 varchar(25)
- );
- SELECT t1.field_1, t2.field_3
- FROM tbl_1 t1
- INNER JOIN tbl_2 t2 ON t1.pk_1 = t2.fk_1
- WHERE t2.field_3 = "Some String"
Add Comment
Please, Sign In to add comment