Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: fini123
  • Content: Threads
  • Order by date
  1. fini123

    merging two queries

    I have an existing query which goes as follows: SELECT job.date, job[job id], clients.[company name], cars.car_registration, clients.[contact name], clients.discount, price_list.[customer price], 5*price)list.[customer price] AS total FROM price_list INNER JOIN (clients INNER JOIN (cars INNER...
  2. fini123

    wierd error

    I'm currently getting a wierd error... when i use the code below... SELECT clients.[company name], cars.car_registration, price_list.[tyre id], -1*(front_left_tyre+front_right_tyre+rear_left_tyre+rear_right_tyre+spare_tyre) AS [tyre quantity], price_list.[customer price], clients.discount...

Part and Inventory Search

Back
Top