Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT id, raw.code, master.name
- FROM
- ( SELECT id, code FROM usedcar ) raw
- JOIN
- ( SELECT code, name FROM brand_master ) master
- ON
- raw.code = master.code
- ORDER BY id
- LIMIT 10
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement