Database with a table b table, a table containing aname, id, such as column, b in the table also contains bname, id column, such as now want to get by query aname bname data, this command needs how to implement, also please give directions, thank you!!!!!! Two id in the table is the same,

CodePudding user response:

SELECT * FROM table_a JOIN table_b WHERE table_a. Id=table_b. Id HAVING table_a. Aname="* *"
Join queries without the main foreign key words

CodePudding user response:

The

references a 1/f, ice ice response:

SELECT * FROM table_a JOIN table_b WHERE table_a. Id=table_b. Id HAVING table_a. Aname="* *"
Join queries without the main foreign key words

I don't write SQL, just think of a more standardized format, change the where to on, instead of having the where more standard,