Re: SQL con condizioni
Posted by:
max dix
Date: May 30, 2008 04:24AM
SELECT UNIX_TIMESTAMP(news.date), news.counter, news.id_user, news.id_news, news.pid, news.title, news.update, programs.name FROM news a left join programs b
on a.
WHERE b.id_program = a.news.pid
ORDER BY news.date DESC
usa la left join, quindi tutte le righe della prima tabella + quelle della seconda se c'e' una corelazione nella chiave indicata.
credo sia questo quello che intendevi.Fammi sapere altrimenti.
MAx
Subject
Views
Written By
Posted
5363
May 22, 2008 09:02AM
Re: SQL con condizioni
3326
May 30, 2008 04:24AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.