s E. Ortiz
De: [EMAIL PROTECTED] en nombre de Pat Maddox
Enviado el: Jue 16/08/2007 02:59 p.m.
Para: pgsql-general@postgresql.org
Asunto: [GENERAL] Help with this query (some join stuff I think)
I've got a bunch of companies that are associated with several videos.
The videos
Pat Maddox wrote:
> I've got a bunch of companies that are associated with several videos.
> The videos have different statuses. I want to select all the
> companies in the database, and order them by videos that have a
> complete status.
>
> Here's what I have so far
>
> SELECT
> companies.i
I've got a bunch of companies that are associated with several videos.
The videos have different statuses. I want to select all the
companies in the database, and order them by videos that have a
complete status.
Here's what I have so far
SELECT
companies.id,
companies.name,
companies.nic
