This post is similar to that of this post : http://www.webassist.com/forums/posts.php?id=34735
As per this : http://www.w3schools.com/sql/sql_join.asp
all results are shown. How to show only one result? main page file attached.
This is the recordset
SELECT artworks.id, artists.name
FROM artworks INNER JOIN artists ON artworks.artist_id=artists.id
Now by this all record shown. I want only one to be shown which is open.
ie name from artists table linked from artist_id from artwork table.