Cancelado

SQL Query, SIMPLE!

OK, this is not even a project. But I would be glad someone could just help me with this. My questions is:

How do i rewrite this SQL-query to also include the field song_id which is next to the songtitle-field in the table songs.

$result = mysql_query("SELECT DISTINCT songtitle FROM songs WHERE view_for_public='y' ");

But that clause doesn't give me the song_id field which I need. So..the same result as the above wuery but also with the song_id field included.

Habilidades: PHP

Ver mais: n query, need sql help, t-sql with, t-sql in, t-sql;, sql, SQL Query, sql project , sql c, simple questions, simple query, query table, C# SQL, rewrite sql, sql select select, sql select, query query, sql query help, sql simple project, sql questions, sql query field, project sql query, simple project sql, project query, sql query project

Acerca do Empregador:
( 34 comentários ) Stockholm, Sweden

ID do Projeto: #128433

8 freelancers estão ofertando em média $30 para este trabalho

NickolaS

Hi, please, check PM

$30 USD in 0 dias
(329 Comentários)
7.5
eelance

very easy ,check pm.

$30 USD in 0 dias
(349 Comentários)
6.8
keyboard999

Hi Sir, Please check on pm.

$30 USD in 0 dias
(115 Comentários)
6.5
pinoywebdev

Hi. SQL Query in PMB.

$30 USD in 0 dias
(37 Comentários)
6.1
bewhite

Easy for me. Please look at the PMB.

$30 USD in 0 dias
(5 Comentários)
4.9
doomer

It's so easy for [url removed, login to view] check the PM.

$30 USD in 0 dias
(0 Comentários)
0.0
Extremity

Check your PM

$30 USD in 0 dias
(0 Comentários)
0.0
billfan88

hi I have ten years experience in SQL let's do it now best regards bill

$30 USD em 1 dia
(0 Comentários)
0.0