0
select accno.tbaccession,classno.tbaccession,bookno.tbaccession,title.tbaccession,author1.tbaccession,status.tb_issue from tbaccession cross join tb_issue where title.tbaccession = '" & Trim(ListBox1.Text) & "';

this code does not work, pls help

Edited by peter_budo: Keep It Clear - Do use code tags when posting any code

3
Contributors
2
Replies
3
Views
6 Years
Discussion Span
Last Post by debasisdas
0

For a start if the table name is tbaccession then the columns should be referenced as tbaccession.accno, etc not accno.tbaccession.
You could also post up the actual error you are getting just to help us help you

0

Your code is horrible.
Columns names are qualified by table name not the reverse as mentioned by you in the SQL.

This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.