var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: sql logic and code question
here(image link) how my table is going to look like;
db screenshot on Flickr - Photo Sharing!
supposing i want to print a message tells who live in the same home
if their street and door numbers are the same.
ahmet,hakan,kaan(name) live at the same home
irem,semih live at the same home
how can i figure out the sql code here?
thx for your answers!
FROM ( SELECT street
HAVING COUNT(*) > 1 ) AS d
JOIN daTable AS t
ON t.street = d.street
AND t.door = d.door
thank you very much. it works fine.
can we add an "id " cloumn which has same id inputs for same "street and door" s? so that i can say same id's live at same place.
it's ok if you suggest another way, thx again