View Single Post
  #9 (permalink)  
Old September 12th, 2005, 03:16 PM
CathyM CathyM is offline
Registered User
 
Join Date: Jul 2005
Location: Castries, n/a, Saint Lucia.
Posts: 4
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Sorry, forgot to add my SQL statement

Dim myAdapter As SqlDataAdapter = New SqlDataAdapter( _
    "SELECT authors.au_id,au_lname, au_fname " & _
        "titles.title_id, title, price " & _
        "FROM authors " & _
        "JOIN titleauthor ON authors.au_id = titleauthor.au_id" & _
        "JOIN titles on titleauthor.title_id = titles.title_id " & _
        "ORDER BY au_lname, au_fname", myConnection)