teampoison's avatar

Fetch Data From Two Tables in MySql

I want to fetch data from tables For first table i want this

SELECT a_id, area, status FROM checklists WHERE area = 'GMA' ORDER BY id DESC;

on second table(abc) a_id is equal to id (means its column name created with id) On second table i want fetch only column money with my first table how i do this

Output

a_id area status (first table data [checklists] table name) money (second table data [abc] table name)

0 likes
2 replies
vincent15000's avatar

You should move the post in another category.

Mix is a package, it doesn't mean miscellaneous subjects.

Please or to participate in this conversation.