-----Original Message----- From: lms-bounce@lists.rulez.pl [mailto:lms-bounce@lists.rulez.pl] On Behalf Of A.L.E.C Sent: Monday, May 10, 2004 11:10 PM To: lms@lists.rulez.pl Subject: [lms] Re: lista taryf

mysql> SELECT a.userid, period, FROM_UNIXTIME(datefrom), FROM_UNIXTIME(dateto) FROM assignments a, tariffs t, users u WHERE u.id = a.userid AND t.id = a.tariffid AND deleted =0 AND t.name ='Internet'; ERROR 1054: Unknown column 'datefrom' in 'field list' mysql>

sorry już zapomniałem o jaką wersję chodziło, dla 1.2 będzie:

SELECT a.userid, period FROM assignments a, tariffs t, users u WHERE u.id = a.userid AND t.id = a.tariffid AND deleted =0 AND t.name ='Internet

-- Pozdrawiam Aleksander Machniak http://k27.prv.pl/alec gg-2275252

nic nie pokazalo ;)

mysql> SELECT a.userid, period FROM assignments a, tariffs t, users u WHERE -> u.id = a.userid AND t.id = a.tariffid AND deleted =0 AND t.name -> ='Internet'; Empty set (0.00 sec)

mysql>