Ask a basic mysql Query question about two tables. one is the image table, and the other is concerned with the table requirements. Find out all the images published by user a and published by user, check uid = a directly in the image table. & nbsp; how can I find out a required statement .... thank you for asking me a basic mysql Query question.
Two tables: an image table and a table of interest
The requirement is as follows: find all the images published by user a and followed by user.
Find the release of a, and check uid = a directly in the image table. Find out how to use a statement to find out the required situation ....
Thank you, mysql.
------ Solution --------------------
Study the union and join syntax.
------ Solution --------------------
Make it clear. for example, whether there are related fields or not, the two tables are independent.
------ Solution --------------------
Paste the table structure ~~
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.