Member Avatar for unaiseek 
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 because: Keep It Clear - Do use code tags when posting any code
  • 3 Contributors
  • 2 Replies
  • 101 Views
  • 10 Hours Discussion Span
  • Latest Post Latest Post by debasisdas
Member Avatar for hericles

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

Member Avatar for debasisdas

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

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.