Pls all,
i want to search for data using two tables e.g
search for date where location = nigeria and state = lagos.
i want it to search for only student from nigeria and state from lagos.
pls how will i go about it.
expecting response soon
omotoyosi
-3
Light Poster
Jx_Man
987
Nearly a Senior Poster
Featured Poster
use JOIN with AND operator in your sql statement.
what the name tables?what the relation between each other? i mean relation between that two tables?
Join will get data from two table and AND operator will get data from your two conditions.
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.