I am trying to create a table that has two columns. If possible I'd like to do that usign two seperate INSERT statements. I am a complete rookie at sql and am learning as I go along. So, please excuse my syntax and statement flow. However, I am getting the following error: "Must pass parameter number 4 and subsequent parameters as '@name = value'. After the form '@name = value' has been used, all subsequent parameters must be passed in the...

I am running the following query:

if (select IntExternalAcco untID from ExternalAccount ) = (select IntExternalAcco untID from InternalAccount )
select * from InternalAccount
where AccountPurpose= 2

and getting the following error
Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression.
...