Paul Burney wrote:
> on 2/28/03 3:15 PM, Daniel Harik at [EMAIL PROTECTED] appended the
> following bits to my mbox:
>
>> Thank You for your reply, but the problem is that users may have many
>> photos, and i need to get only one, i use folllowing sql:
>> SELECT users.username, photos.file FROM u
Mark wrote:
>
> --- Daniel Harik <[EMAIL PROTECTED]> wrote:
>> > > Hello,
>> > >
>> > > I have 2 tables users table, that stores user info, and photos
>> table,
>> > > i want to select all users with one photo form photos table,
>> but i don't
>> > > want it to be photos * users = result.
>> > >
--- Daniel Harik <[EMAIL PROTECTED]> wrote:
> > > Hello,
> > >
> > > I have 2 tables users table, that stores user info, and photos
> table,
> > > i want to select all users with one photo form photos table,
> but i don't
> > > want it to be photos * users = result.
> > >
> > > Is there way to do
on 2/28/03 3:15 PM, Daniel Harik at [EMAIL PROTECTED] appended the following
bits to my mbox:
> Thank You for your reply, but the problem is that users may have many
> photos, and i need to get only one, i use folllowing sql:
> SELECT users.username, photos.file FROM users left join photos on
> us
4 matches
Mail list logo
