-bash: ls: command not found at Terminal on Mac OS X

Question

I have two queries which I want to join together. Unionoption will not work as I want the values to be displayed in different fields. The 1st query is

 SELECT Outage.DISTRICT, Count(Outage.DISTRICT) AS CountOfDISTRICT
 FROM Outage LEFT JOIN [Site ID gets generated] ON Outage.[Site ID]=[Site ID gets     generated].[Site ID]
 GROUP BY Outage.DISTRICT;

The 2nd query is

SELECT Outage.DISTRICT, Count(Outage.[Site ID]) AS [CountOfSite ID]
FROM Outage
GROUP BY Outage.DISTRICT;

I tried the below code but it is giving syntax error (missing operator) in the 1st query

SELECT Outage.DISTRICT,
(SELECT  Count(Outage.[Site ID]) AS [CountOfSite ID] FROM Outage),
(SELECT  Count(Outage.DISTRICT) AS CountOfDISTRICT FROM Outage LEFT JOIN [Site ID gets generated] ON Outage.[Site ID]=[Site ID gets generated].[Site ID])
GROUP BY Outage.DISTRICT;

It would be very helpful if answer is also given with an explanation, as I am quite new to access and trying to learn it from scratch.

Solution

Your $PATH was overwritten by MacPorts in error. This is my $PATH with MacPorts installed, you should edit it accordingly and set it in your ~/.bash_profile or ~/.profile.

blackcomb:~ tyson$ echo $PATH
/opt/local/bin:/opt/local/sbin:/usr/bin:/bin:/usr/sbin:/sbin:/usr/local/bin:/opt/X11/bin:/usr/X11/bin

Specifically, you are missing /bin, /usr/bin, /usr/sbin, /sbin, /usr/local/bin and /usr/X11/bin.

Comments

[squircle]

Consider copying your solution from your question and adding it as an answer (or accepting an existing answer) so other people know how you fixed your problem.

[MEM]

If you wish, instead of using textwrangler and navigate to the hidden files on finder, you may also use the absolute path of pico for example, by doing, inside your profile file directory, the following: $~ /usr/bin/pico .bash_profile.

[Soumyajit]

Thanks friend it worked.#Respect. By the way can you tell me more about 'JOINS',basically their difference

[Yawar]

@Soumyajit - sure, there's a good description here: stackoverflow.com/questions/448023/…