Ntshoekeleng
Last Activity: May 30 '12, 04:16 PM
Joined: May 30 '12
Location:
-
The sum of the two values -
Inner join artwork on artwork.artwork _code=artwork_s old.artwork_cod e
i have used this code and now it repeats twice and not for timesLeave a comment:
-
The common field is artwork_codeLeave a comment:
-
Oh ok..Il see how i solve this one.Leave a comment:
-
still doesn't work..Leave a comment:
-
Love lost 2011-07-12 00:00:00.000 Painting Oil Contempory 2011-05-15 00:00:00.000 15000.00
Love lost 2011-07-12 00:00:00.000 Painting Oil Contempory 2011-05-15 00:00:00.000 150000.00
My Queen 2011-10-10 00:00:00.000 Sculpture Mixed Folk 2009-08-17 00:00:00.000 15000.00
My Queen 2011-10-10 00:00:00.000 Sculpture Mixed Folk 2009-08-17 00:00:00.000 150000.00
Reality 2011-08-17 00:00:00.000 Sculpture Marble Impressionist 2010-05-28...Leave a comment:
-
Repeating in sql query, how to remove
...Code:SELECT ARTWORK.TITLE AS 'Title',ARTWORK.DATE_LISTED AS 'Date Listed', ARTWORK.USUAL_TYPE as 'Type',ARTWORK.USUAL_MEDIUM as 'Medium', ARTWORK.USUAL_STYLE as 'Style', ARTWORK.YEAR_COMPLETED as 'Year',ARTWORK_SALES.ASKING_PRICE as 'Asking Price' FROM ARTWORK_SALES,ARTWORK_SOLD INNER JOIN ARTWORK ON ARTWORK.ARTWORK_CODE=ARTWORK.ARTWORK_CODE GROUP BY TITLE, ARTWORK.TITLE,ARTWORK.DATE_LISTED,ARTWORK.USUAL_TYPE,ARTWORK.USUAL_MEDIUM,ARTWORK.USUAL_STYLE,
No activity results to display
Leave a comment: