2PTTechnology

The platform that enables you to build rich, interactive communities
Welcome to 2PTTechnology Sign in | Join | Help
in Search

Microsoft Query Show/Hide Tables & Show/Hide Criteria buttons do nothing

Last post 03-04-2008, 11:14 AM by twaligora. 0 replies.
Sort Posts: Previous Next
  •  03-04-2008, 11:14 AM 131

    Microsoft Query Show/Hide Tables & Show/Hide Criteria buttons do nothing

     

    The reason that the buttons don’t display the tables or the criteria is that the SQL was modified, most likely with an inner join.

    To fix this issue you pretty much need to know SQL and remove the inner joins.

     

    Example of SQL:

     

    (with inner join)

    Select

       Student.FirstName,

       Student.LastName,

       Addr.Address

    From

       StudentTbl Student

       inner join AddressTbl Addr on Addr.Id = Student.Address_id

    ------------------------------------------------------------------------------------------

    (without Inner Join)

    Select

       Student.FirstName,

       Student.LastName,

       Addr.Address

    From

       StudentTbl Student,

       AddressTbl Addr

    where

       Addr.Id = Student.Address_id

     

     

View as RSS news feed in XML
Powered by Community Server (Personal Edition), by Telligent Systems