[sqlite] Select from Select

; Postcode field is called Postcode; Telephone field is called Tel; Canvass field is called Canvass Many thanks for any help, Brian Pugh

[sqlite] Select from a Select

see there is "create view" and it probably appears to be what I want, but I have no idea how to apply it, or make a "pre-packaged" select Any answers or suggestions would be most gratefully welcomed Thanks a lot, Brian Pugh

[sqlite] Jumping to a record

12345, how would it be possible to "jump" to that record, and still maintain my original select parameters and order? I guess that this is down to a select within a select, but I'm not sure how to go about it. Well, I'll qualify that - anything that I've tried hasn't worked yet! Thanks a lot, Brian Pugh, Halifax, England

[sqlite] Re: Jump to record

Bronislav, Mrs Brisby and Derrell, Thanks a lot for your interest. It now remains for me to try your suggestions Thanks again, Brian

[sqlite] Indexes

to view I have obviously got the wrong end of the stick about indexes! Could someone put me right, or point me gently in the right direction? Thanks, Brian Pugh

[sqlite] Changing a Field

Hi, I need to do a multiple search and replace on the same field in my database. Can anyone suggest a suitable bit of code for this? I have over 100,000 records, so any automation is very welcome! Thanks for any suggestions, Brian Pugh

[sqlite] Help with query

the above query is successful, I want it to include the columns called Code, Shopname, Address1 and Price, but only if the Shopname column in the Agents table matches either Shop1 or Shop2 in the NewsData table Can anyone help me with this? Regards, Brian Pugh

Re: [sqlite] Help with query

Fred, A query I can understand! This was my attempt, and worked to some degree, but yours is more workable and, I feel, more accurate "select NewsData.Postcode,NewsData.Address1,Agents.Code,Agents.Shopname,Agents.Addre ss1.Agents.Price from NewsData join Agents on NewsData.Postcode where