Before anything else I"m using MyISAM since my hosting don’t support InnoDB.
I have two tables that has columns,
1st table: users_swap
and the columns are
usid,
us_id,
swap_id
note: us_id came from 'users' table.
2nd table: swap
and the columns are
swap_id,
date_posted,
offering,
seeking
I want to SELECT swap_id and offering columns from swap table.
Using a specific user_id from users_swap table
I hope I explained it clearly.
So what is the right SELECT syntax?
Thank you very very much in advanced.