Joins vs Multiple queries

Hi ...

 I am writing reports using SQR ver 2.27 when a thought crossed my mind.  Is there a great difference in performance when writing queries  (be in plain sql statements, embedded sql, or using report writer)   using joins as opposed to using multiple queries instead ?

 The thing is both ways satisfies my need but I am more worried about  performance when the database is large and queries retrieves many, many  records. Joins may be good since it accesses the databse once (is that  true ?) but what if it joins too many tables ? Is there a preferred way  to handle such cases ? Anyone care to share their experience/advice ?

 I hope that this isn't a silly question ! :)  Have a nice day ! Received on Sat Jun 26 1993 - 21:52:00 CEST