List:General Discussion« Previous MessageNext Message »
From:Martijn Tonies Date:May 9 2007 5:27pm
Subject:Re: Query problem
View as plain text  
> how do I return a single row per property even if it has 3 or 4 images
> attached to it.

Please reply to the list instead of directly to me.

You could do a:

select p.from properties p where exists (select i.* from images i
where i.property_id = p.property_id)

> > >I have a table of properties that is linked to a table  f images with a
> > >one
> > property to many images relationship. I >have manged this with nested
> > queries but want to try and do it on one line. My current query
> >>
> >>$query = "SELECT * FROM images, properties WHERE images.property_id =
> > properties.property_id";
> >>
> >>As you can see from the query this returns a row for every image so if a
> > property has 3 images associated with it >it will be returned 3 times.
> >
> > What exactly is your question?

Martijn Tonies
Database Workbench - development tool for MySQL, and more!
Upscene Productions
My thoughts:
Database development questions? Check the forum!

Query problemross9 May
  • Re: Query problemMartijn Tonies9 May
    • Re: Query problemJon Ribbens9 May
  • Re: Query problemross9 May
  • Re: Query problemMartijn Tonies9 May